package com.rsk.dao;


import java.io.Serializable;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import com.rsk.entity.SysRoleMenu;


@Repository
public interface SysRoleMenuRepository extends JpaRepository<SysRoleMenu, Long>,JpaSpecificationExecutor<SysRoleMenu>,Serializable {
	
	@Modifying
	@Query(value = "delete from sys_user_role where role_id =?1 and is_del = -3", nativeQuery = true)
	public int delSysRoleMenuByRoleId(Long roleId);
	
}
 